--Enable Full Text Search for the database
USE [BdMarket]
Go
EXEC sp_fulltext_database 'enable'
go

--Create Catelog/Index
GO
CREATE UNIQUE INDEX ui_ProductSearch  ON ProductIndex(ProductID);
CREATE FULLTEXT CATALOG ft_ProductSearch AS DEFAULT;
CREATE FULLTEXT INDEX ON ProductIndex(Description) 
   KEY INDEX ui_ProductSearch 
GO

